//
//  SQLiteUtil.h
//  AlarmClock
//
//  Created by Fedor Skrynnikov on 9/20/12.
//  Copyright (c) 2012 __MyCompanyName__. All rights reserved.
//

#import <UIKit/UIKit.h>
#import "sqlite3.h"


@interface SQLiteUtil : NSObject{
    @private NSMutableString* dbPath;
    @private sqlite3* dbSQL;
}

- (id) init;
- (BOOL) createDBNamedAndDeleteIfExists: (BOOL) toDelete;
- (void) createTable: (NSString*)tableName;
- (void) deleteTable: (NSString*)tableName;
- (void) insertInTable: (NSString*)tableName Name:(NSString*)name Note:(NSString*)note Recurence:(NSString*)recurence Date:(NSString*)date;
- (void) updateImageInTable: (NSString*) tableName WhereId:(NSInteger)id DataImage:(NSData*)dataImage;
- (void) deleteFromTable:(NSString *)tableName record:(NSString *)recordId;
- (NSMutableArray*) selectFromTable: (NSString*)tableName;

@end
